home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1994 #2
/
Monster Media No. 2 (Monster Media)(1994).ISO
/
clipper
/
mrddem.zip
/
DATA.PRG
< prev
next >
Wrap
Text File
|
1994-06-29
|
2KB
|
91 lines
External SIXNSX, DBFCMX
FIELD Info, aMemo, cKey, nKey, Num1, Num2, Num3, Num4
FUNCTION BrowData()
IF !FILE("DATA1.DBF")
Data1Create()
ELSE
USE Data1 NEW VIA "DBFCMX" SHARED READONLY
ENDIF
IF ! FILE("Data2.dbf")
data2Create()
ELSE
USE Data2 NEW VIA "SIXNSX"
ENDIF
ALTD(6) // Summon the workarea list
CLOSE ALL
RETURN(NIL)
FUNCTION Data2Create()
LOCAL nI := 0
LOCAL aDBF2 := { {"Info", "C", 50, 0},;
{"AMemo", "M", 10, 0 },;
{"cKey", "C", 5, 0 },;
{"nKey", "N", 5, 0 }}
LOCAL aInfo := { "Press F1 for brief help on this screen",;
"Each window has different options",;
" ",;
"The last record is blank because it ",;
"is an EOF record",;
" ",;
"You can press RETURN on nearly",;
"everything here",;
" ",;
"Try it, press RETURN on the array",;
"stored in the SMT file" }
DBCREATE("Data2", aDBF2, "SIXNSX")
USE Data2 NEW VIA "SIXNSX"
FOR nI := 1 TO LEN(aInfo)
data2->(DBAPPEND())
data2->Info := aInfo[nI]
data2->amemo := Ainfo
data2->cKey := LTRIM(STR(nI))
data2->nKey := 20 - nI
NEXT
data2->(DBCOMMIT())
INDEX ON cKey TAG Index1
INDEX ON nKey TAG Index2
Data2->(DBSetOrder(1))
Data2->(DBGOTOP())
RETURN(NIL)
FUNCTION Data1Create()
LOCAL nI := 0
LOCAL aDBF1 := { {"Num1", "N", 10, 0},;
{"Num2", "N", 10, 0},;
{"Num3", "N", 10, 0},;
{"Num4", "N", 10, 0} }
DBCREATE("Data1", aDBF1, "DBFCMX")
USE Data1 NEW VIA "DBFCMX" SHARED
FOR nI := 1 TO 100
data1->(DBAPPEND())
data1->Num1 := nI
data1->Num2 := 100-nI*10
data1->Num3 := (100-Ni)*.175
data1->Num4 := 100-nI
NEXT
data1->(DBCOMMIT())
INDEX on data1->Num1 TAG num1
INDEX on data1->Num2 TAG num2
INDEX on data1->Num3 TAG num3
INDEX on data1->Num4 TAG num4
Data1->(DBGOTOP())
RETURN(NIL)